My Stuff
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
-
Saved Search | Show Built Qty and Used in Build Qty in Work Orders
Scenario User is creating a Transaction Saved Search for Work Orders and needs to show the values in the Built field (Main Line) and Used In Build column (Item Line). While there is already a Built f…1 -
TOP CONTRIBUTOR FOR JULY 2022!
Congratulations for being our Top Contributor for July 2022, @Emil T.! We truly appreciate your active participation last month and we look forward to seeing more of your contributions in our communi…4 -
Re: COUNT in a saved search formula
Hi Oliver, You mentioned in a previous comment that you wanted to concatenate the results per Sales Rep, which is what the formula I provided is doing. Based on your most recent comment, what you are…1 -
Re: Saved Search Formula: Dividing Two Columns: Debit Amount/Quantity
Hi @User_1K0CO, Try this in a Formula (Currency) field with either Maximum, Minimum, Average or Sum as the Summary Type: SUM({debitamount})/SUM({quantity}) Let us know if this works for you. -Ivy ===…1 -
Re: Zero in a saved search drops off in the results
Hi @Vernita, It seems that is the standard behavior when using a Formula (Text) field and the result is a decimal number that is less than 0. I did a simple test on my account that proves this: Resul…1
